/*河南星辰软件科技有限公司
@copyright Copyright (c) 2010~2022 All rights reserved.
*/
package cn.javaxc.crm.action.sale;
import java.io.*;
import java.util.*;
import java.sql.*;
import cn.javaxc.model.base.SQL;
import cn.javaxc.model.base.SQLList;
import cn.javaxc.model.base.SQLMap;
import cn.javaxc.model.base.SQLParam;
import cn.javaxc.model.page.BatisPage;
import cn.javaxc.mvcwork.controller.web.TreeBean;
import cn.javaxc.mvcwork.util.common.CommonUtil;
import cn.javaxc.mvcwork.util.common.MapListUtil;
import cn.javaxc.mvcwork.util.helper.FrameHelper;
import cn.javaxc.mvcwork.util.helper.TreeTableHelper;
import org.springframework.beans.factory.annotation.Autowired;
import cn.javaxc.system.action.base.BaseAction;
import cn.javaxc.crm.mapper.sale.CustomerMapper;
public class CustomerAction extends BaseAction
{
    @Autowired(required=false)
	private CustomerMapper mapper;
    /**
    客户联系人任务
    */
    
    public Map customer() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_task=mapper.s_task(params);
        result.put("s_task", s_task);
        
        return result;
    }
    /**
    选择公共关系电话
    */
    
    public Map customerContactsPubPhone() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_phone=mapper.s_phone(params);
        result.put("s_phone", s_phone);
        
        return result;
    }
    /**
    客户联系人传真
    */
    
    public Map customerContactsFax() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> fasongqingkuangmingxi=mapper.fasongqingkuangmingxi(params,pagination);
        fasongqingkuangmingxi.setPagedListInfo(pagination);
        fasongqingkuangmingxi.setSelectNone("发送情况明细");
        result.put("fasongqingkuangmingxi", fasongqingkuangmingxi);
        
        return result;
    }
    /**
    传真明细
    */
    
    public Map faxDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_recipient=mapper.s_recipient(params);
        SQLMap s_recipient_emt=s_recipient.getExistfirst();
        result.put("s_recipient", s_recipient_emt);
        
        
        SQLList<SQLMap> s_file=mapper.s_file(params);
        result.put("s_file", s_file);
        
        return result;
    }
    /**
    选择传真号码
    */
    
    public Map faxChoiceNum() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_phone=mapper.s_phone(params);
        result.put("s_phone", s_phone);
        
        return result;
    }
    /**
    客户联系人邮件
    */
    
    public Map customerContactsEmail() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> fasongqingkuangmingxi=mapper.fasongqingkuangmingxi(params,pagination);
        fasongqingkuangmingxi.setPagedListInfo(pagination);
        fasongqingkuangmingxi.setSelectNone("发送情况明细");
        result.put("fasongqingkuangmingxi", fasongqingkuangmingxi);
        
        return result;
    }
    /**
    选择公共关系邮箱
    */
    
    public Map emailPubChoice() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_email=mapper.s_email(params);
        result.put("s_email", s_email);
        
        return result;
    }
    /**
    邮件明细
    */
    
    public Map emailDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> fujianmingxi=mapper.fujianmingxi(params);
        fujianmingxi.setSelectNone("附件明细");
        result.put("fujianmingxi", fujianmingxi);
        
        
        SQLList<SQLMap> xuanzelianxirenmingxi=mapper.xuanzelianxirenmingxi(params);
        xuanzelianxirenmingxi.setSelectNone("选择联系人明细");
        result.put("xuanzelianxirenmingxi", xuanzelianxirenmingxi);
        
        
        SQLList<SQLMap> xiaoximingxi=mapper.xiaoximingxi(params);
        SQLMap xiaoximingxi_emt=xiaoximingxi.getExistfirst();
        result.put("xiaoximingxi", xiaoximingxi_emt);
        
        return result;
    }
    /**
    */
    
    public Map d_task() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_task(params);
        
        return result;
    }
}